/*
 Navicat MySQL Data Transfer

 Source Server         : yulong
 Source Server Version : 50629
 Source Host           : 119.23.54.1
 Source Database       : shuqian

 Target Server Version : 50629
 File Encoding         : utf-8

 Date: 08/25/2019 17:19:56 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `tp_admin`
-- ----------------------------
DROP TABLE IF EXISTS `tp_admin`;
CREATE TABLE `tp_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(30) NOT NULL,
  `password` char(32) NOT NULL DEFAULT '',
  `role` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `tp_admin`
-- ----------------------------
BEGIN;
INSERT INTO `tp_admin` VALUES ('1', 'test', '123', 'level_1_admin');
COMMIT;

-- ----------------------------
--  Table structure for `tp_config`
-- ----------------------------
DROP TABLE IF EXISTS `tp_config`;
CREATE TABLE `tp_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `varname` varchar(80) NOT NULL,
  `info` varchar(80) NOT NULL,
  `value` text NOT NULL,
  `valuetype` varchar(20) NOT NULL,
  `grouptype` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `tp_config`
-- ----------------------------
BEGIN;
INSERT INTO `tp_config` VALUES ('1', 'cfg_top_banner', '设置页面首页的banner图片地址', '5438f90ad2cbd.jpg', 'upload', 'other'), ('2', 'cfg_game_star_time', '活动开始时间(格式 2014-01-23 08:00:00)', '2015-01-23 09:00:00', 'input', 'game'), ('3', 'cfg_game_end_time', '活动结束时间(格式 2014-01-23 08:00:00)', '2019-12-29 00:00:00', 'input', 'game'), ('6', 'cfg_game_rule', '活动规则说明', '1.于上方九宫格活动区点击图片,使之移动进行拼图；\r\n2.首次点击图片即开始计时；\r\n3.完成后请提交完整资料；\r\n4.最快速度完成拼图的前35名用户将获得奖品。\r\n', 'textarea', 'other'), ('7', 'cfg_game_finish', '活动结束后的提示语句', '本次活动已结束!', 'input', 'game'), ('8', 'cfg_game_end_say', '游戏结束后的提示语句', '恭喜您！您使用了(*)秒成功拼图', 'input', 'other'), ('9', 'cfg_share_friend_say', '游戏结束后分享朋友圈的语句', '我参加了一汽马自达CX-7拼图游戏用时(*)秒。快来挑战我吧！', 'input', 'other'), ('14', 'cfg_appid', '微信APPID', 'wx70d83150c0a57c91', 'input', 'weixin'), ('15', 'cfg_screct', '微信SECRET', '72114fafe22bfeac6bdcc4e615c19b8c', 'input', 'weixin'), ('16', 'cfg_gift', '活动奖品', '1.第1-5名将获得拆盒网提供的NECA《环太平洋》澳洲机甲1只；\r\n2.第6-35名将获得手游画报提供的精美大礼包1份。 ', 'textarea', 'other'), ('17', 'cfg_game_note', '活动解释权', '本活动最终解释权归XXX所有', 'input', 'other'), ('18', 'cfg_wx_share_title', '微信分享标题', '榕林时光', 'input', 'weixin'), ('19', 'cfg_wx_share_desc', '微信分享描述', '我参加疯狂数钱活动,太刺激了,你敢来挑战吗?', 'input', 'weixin'), ('20', 'cfg_wx_share_pic', '微信分享图片地址(绝对路径)', 'http://shuqian.ifsvc.cn/Public/Images/icon.jpg', 'input', 'weixin'), ('21', 'cfg_wx_share_url', '微信分享跳转地址', 'http://shuqian.ifsvc.cn/index.php/Index/index.html', 'input', 'weixin'), ('22', 'cfg_isoauth_open', '是否开启微信授权模式（1开始，0关闭）', '1', 'input', 'other'), ('23', 'cfg_oauth_cb_url', '微信授权成功后回调地址', 'http://shuqian.ifsvc.cn/index.php/Index/index.html', 'input', 'weixin'), ('24', 'cfg_my_id', '我的公众号对应的微信ID', ' gh_83d6b8257077', 'input', 'other'), ('25', 'cfg_base_url', '网站首页地址', 'http://localhost:8080/index.php/Index/index.html', 'input', 'other'), ('26', 'cfg_homepage_title', '首页标题', '榕林•时光', 'input', 'system'), ('27', 'cfg_tongji_code', '统计代码', '<span style=\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"display:none\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"><script type=\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"text/javascript\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\">var cnzz_protocol = ((\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"https:\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\" == document.location.protocol) ? \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\" https://\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\" : \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\" http://\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\");document.write(unescape(\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"%3Cspan id=\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'cnzz_stat_icon_1000523831\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'%3E%3C/span%3E%3Cscript src=\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\" + cnzz_protocol + \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"s4.cnzz.com/z_stat.php%3Fid%3D1000523831%26show%3Dpic\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\' type=\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'text/javascript\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'%3E%3C/script%3E\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"));</script>\r\n</span>', 'textarea', 'other'), ('30', 'cfg_homepage_bg', '首页背景图', '54c13c657b6e2.jpg', 'upload', 'other'), ('48', 'cfg_share_count', '分享总次数', '374', 'input', 'other'), ('50', 'cfg_oauth_cb_url2', '微信授权成功后回调地址(关注页面使用)', 'http://ww.wayhu.com/guaguaka/index.php/Index/toSharePage', 'input', 'other'), ('51', 'cfg_pass_score', '通关金额', '1000', 'input', 'game'), ('52', 'cfg_pass_time', '通关时间(秒)', '10', 'input', 'game'), ('53', 'cfg_allow_reference', '允许来源地址', 'www.ifsvc.cn', 'input', 'game'), ('54', 'cfg_jump_page', '跳转到来源网址的网页', 'http://www.ifsvc.cn/posts/115', 'input', 'game'), ('55', 'cfg_total_redpack', '红包发放总额上限', '3000', 'input', 'game');
COMMIT;

-- ----------------------------
--  Table structure for `tp_redpack`
-- ----------------------------
DROP TABLE IF EXISTS `tp_redpack`;
CREATE TABLE `tp_redpack` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `wxid` varchar(45) DEFAULT NULL,
  `score` int(11) NOT NULL DEFAULT '0' COMMENT '得分',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0未发，1已发',
  `remark` varchar(100) NOT NULL,
  `created` varchar(20) NOT NULL,
  `updated` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1000006 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `tp_score`
-- ----------------------------
DROP TABLE IF EXISTS `tp_score`;
CREATE TABLE `tp_score` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `score` int(11) NOT NULL,
  `joindate` datetime NOT NULL,
  `uid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `tp_user`
-- ----------------------------
DROP TABLE IF EXISTS `tp_user`;
CREATE TABLE `tp_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL,
  `userphone` varchar(30) NOT NULL,
  `is_exchange` tinyint(4) NOT NULL,
  `regtime` datetime NOT NULL,
  `wxid` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

SET FOREIGN_KEY_CHECKS = 1;
